Controlling Which Datasources Are Geospatial Enabled

After you create the geospatial tables in the database, there is nothing else you need to do in order to geospatial enable a datasource. However, if you want some of your datasources to be geospatial enabled and some not, or if you want to prevent the geospatial tables from being created in a particular datasource, then you must do some configuration in the ProjectWise Design Integration Server's DMSKRNL.CFG file located in the ...\ProjectWise\bin folder.

Important: Always remember to restart the service for the ProjectWise Design Integration Server after you enable or disable geospatial functionality in the DMSKRNL.CFG file in order for the setting to take effect.

At the bottom of the DMSKRNL.CFG file is a list of all the datasources running on this server with headings [db0], [db1], [db2], and so on, where [db0] represents the first datasource created, [db1] the second, [db2] the third, and so on. Information provided includes datasource display name, description, name of ODBC datasource used, type of database used, and username and password for database user and admin user. This information is added to the file when the datasource is created.

For each datasource that you want geospatial functionality to be enabled, add the line:

GeoDatasource = True

For each datasource that you want geospatial functionality to be disabled, add the line:

GeoDatasource = False

For example:

[db0]
DBUsrPwdDecrypt=4
InterfaceType=ODBC
Type=Microsoft SQL Server
DBUserName=sa
DBUserPassword=#x/e62eidKOstv1Y0HZoMyX3VFrLe/kdFukTd/qxRyLmLw1G5
Description=GSSDemo
Name=GSSDemo
GeoDatasource = True

[db1]
DBUsrPwdDecrypt=4
InterfaceType=ODBC
Type=Microsoft SQL Server
DBUserName=sa
DBUserPassword=#x/e62eidKOstv1Y0HZoMyX3VFrLe/kdFukTd/qxRyLmLw1G5
Description=Test
Name=Test
GeoDatasource = False

When you disable geospatial functionality for a datasource, you will not be prompted to create the geospatial tables in the database, and no geospatial nodes will display in ProjectWise Administrator; in other words, the geospatial functionality will not be available in that datasource. Disabling geospatial functionality in a datasource does not remove geospatial tables from the database if they were already created.

Change the line from GeoDatasource = False to GeoDatasource = True if you want to enable geospatial functionality in a datasource where it was previously disabled.

When you enable geospatial functionality for an existing datasource that does not yet have the geospatial database tables, you will be prompted to create the geospatial database tables the next time you log in to that datasource in ProjectWise Administrator.

You can also use a global setting to either enable or disable geospatial functionality for all datasources on this server, and then use the datasource level setting to explicitly enable or disable geospatial functionality on a per-datasource basis.

For example, add this global setting to disable geospatial functionality for all datasources of this server:

[Geocfg]
GeoDatasource = False

Next, add the GeoDatasource = True line to the bottom of only the datasources for which you want to enable geospatial functionality:

[db0]
DBUsrPwdDecrypt=4
InterfaceType=ODBC
Type=Microsoft SQL Server
DBUserName=sa
DBUserPassword=#x/e62eidKOstv1Y0HZoMyX3VFrLe/kdFukTd/qxRyLmLw1G5
Description=GSSDemo
Name=GSSDemo
GeoDatasource = True

Note: When the global setting is present, new datasources will automatically be either geospatial enabled or disabled, depending on how the global setting is set (True or False).

Note: When the global setting is absent, it is the same as if the global setting were present and set to True; in either case, all datasources are assumed to be geospatial enabled unless you explicitly add the line GeoDatasource = False to a particular datasource, and there is no need to add the line GeoDatasource = True to a datasource to geospatial enable it.